Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	5012
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	3
Duplicate rows (%)	0.1%
Total size in memory	598.6 KiB
Average record size in memory	122.3 B

Variable types

Categorical	2
Numeric	14

Alerts

Dataset has 3 (0.1%) duplicate rows	Duplicates
`host_listings_minimum_nights` is highly overall correlated with `log_host_listings_count` and 1 other fields	High correlation
`latitude` is highly overall correlated with `longitude` and 1 other fields	High correlation
`log_host_listings_count` is highly overall correlated with `host_listings_minimum_nights`	High correlation
`log_minimum_nights` is highly overall correlated with `host_listings_minimum_nights`	High correlation
`log_number_of_reviews` is highly overall correlated with `log_reviews_per_month`	High correlation
`log_price` is highly overall correlated with `price` and 3 other fields	High correlation
`log_reviews_per_month` is highly overall correlated with `log_number_of_reviews`	High correlation
`longitude` is highly overall correlated with `latitude` and 1 other fields	High correlation
`neighbourhood` is highly overall correlated with `latitude` and 1 other fields	High correlation
`price` is highly overall correlated with `log_price` and 3 other fields	High correlation
`price^2` is highly overall correlated with `log_price` and 3 other fields	High correlation
`price^3` is highly overall correlated with `log_price` and 3 other fields	High correlation
`price^4` is highly overall correlated with `log_price` and 3 other fields	High correlation
`price^2` is highly skewed (γ1 = 25.38358231)	Skewed
`price^3` is highly skewed (γ1 = 34.81686362)	Skewed
`price^4` is highly skewed (γ1 = 39.25340936)	Skewed
`log_minimum_nights` has 1521 (30.3%) zeros	Zeros
`log_host_listings_count` has 2106 (42.0%) zeros	Zeros
`host_listings_minimum_nights` has 3018 (60.2%) zeros	Zeros

Reproduction

Analysis started	2025-03-01 00:40:57.400980
Analysis finished	2025-03-01 00:41:10.120476
Duration	12.72 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

neighbourhood
Categorical

High correlation

Distinct	30
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	45.3 KiB

West Town	566
Near North Side	532
infrequent	528
Lake View	418
Logan Square	299
Other values (25)	2669

Length

Max length	18
Median length	14
Mean length	10.851157
Min length	4

Characters and Unicode

Total characters	54386
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	infrequent
2nd row	North Center
3rd row	Logan Square
4th row	Rogers Park
5th row	South Shore

Common Values

Value	Count	Frequency (%)
West Town	566	11.3%
Near North Side	532	10.6%
infrequent	528	10.5%
Lake View	418	8.3%
Logan Square	299	6.0%
Loop	287	5.7%
Lincoln Park	259	5.2%
Near West Side	258	5.1%
Lower West Side	153	3.1%
Edgewater	137	2.7%
Other values (20)	1575	31.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
side	1057	10.9%
west	1032	10.6%
near	904	9.3%
park	793	8.2%
north	644	6.6%
town	566	5.8%
infrequent	528	5.4%
lake	418	4.3%
view	418	4.3%
square	417	4.3%
Other values (26)	2932	30.2%

Most occurring characters

Value	Count	Frequency (%)
e	6686	12.3%
	4697	8.6%
r	4576	8.4%
o	3679	6.8%
a	3602	6.6%
n	3286	6.0%
t	3094	5.7%
i	2717	5.0%
d	1871	3.4%
S	1736	3.2%
Other values (31)	18442	33.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54386	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	6686	12.3%
	4697	8.6%
r	4576	8.4%
o	3679	6.8%
a	3602	6.6%
n	3286	6.0%
t	3094	5.7%
i	2717	5.0%
d	1871	3.4%
S	1736	3.2%
Other values (31)	18442	33.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54386	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	6686	12.3%
	4697	8.6%
r	4576	8.4%
o	3679	6.8%
a	3602	6.6%
n	3286	6.0%
t	3094	5.7%
i	2717	5.0%
d	1871	3.4%
S	1736	3.2%
Other values (31)	18442	33.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54386	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	6686	12.3%
	4697	8.6%
r	4576	8.4%
o	3679	6.8%
a	3602	6.6%
n	3286	6.0%
t	3094	5.7%
i	2717	5.0%
d	1871	3.4%
S	1736	3.2%
Other values (31)	18442	33.9%

latitude
Real number (ℝ)

High correlation

Distinct	4226
Distinct (%)	84.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.899279

Minimum	41.64736
Maximum	42.02251
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	41.64736
5-th percentile	41.782967
Q1	41.873238
median	41.901885
Q3	41.939765
95-th percentile	41.988189
Maximum	42.02251
Range	0.37515
Interquartile range (IQR)	0.0665275

Descriptive statistics

Standard deviation	0.058870345
Coefficient of variation (CV)	0.0014050443
Kurtosis	0.79813379
Mean	41.899279
Median Absolute Deviation (MAD)	0.0344
Skewness	-0.72376333
Sum	209999.19
Variance	0.0034657175
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.88306	19	0.4%
41.89111	15	0.3%
41.88608	14	0.3%
41.89063	13	0.3%
41.88558	11	0.2%
41.92819	11	0.2%
41.89862	8	0.2%
41.88652	7	0.1%
42.01653	7	0.1%
41.89235	7	0.1%
Other values (4216)	4900	97.8%

Value	Count	Frequency (%)
41.64736	1	< 0.1%
41.65208	1	< 0.1%
41.65388	1	< 0.1%
41.65578	1	< 0.1%
41.65977	1	< 0.1%
41.68289	1	< 0.1%
41.68612	1	< 0.1%
41.6883	1	< 0.1%
41.68906	1	< 0.1%
41.68909	1	< 0.1%

Value	Count	Frequency (%)
42.02251	1	< 0.1%
42.02139	1	< 0.1%
42.02119	1	< 0.1%
42.02105	1	< 0.1%
42.02087	1	< 0.1%
42.02077	1	< 0.1%
42.02042	1	< 0.1%
42.01957	1	< 0.1%
42.01947	1	< 0.1%
42.01926	1	< 0.1%

longitude
Real number (ℝ)

High correlation

Distinct	4036
Distinct (%)	80.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-87.664064

Minimum	-87.84681
Maximum	-87.53752
Zeros	0
Zeros (%)	0.0%
Negative	5012
Negative (%)	100.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	-87.84681
5-th percentile	-87.736168
Q1	-87.686782
median	-87.660935
Q3	-87.633365
95-th percentile	-87.604236
Maximum	-87.53752
Range	0.30929
Interquartile range (IQR)	0.0534175

Descriptive statistics

Standard deviation	0.042663199
Coefficient of variation (CV)	-0.00048666692
Kurtosis	1.2919833
Mean	-87.664064
Median Absolute Deviation (MAD)	0.02703
Skewness	-0.67734759
Sum	-439372.29
Variance	0.0018201486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.65131	17	0.3%
-87.63422	15	0.3%
-87.62205	15	0.3%
-87.61903	14	0.3%
-87.6525	13	0.3%
-87.6257	12	0.2%
-87.62797	8	0.2%
-87.62472	7	0.1%
-87.62732	7	0.1%
-87.65159	7	0.1%
Other values (4026)	4897	97.7%

Value	Count	Frequency (%)
-87.84681	1	< 0.1%
-87.84527	1	< 0.1%
-87.84474	1	< 0.1%
-87.84363	1	< 0.1%
-87.84196	1	< 0.1%
-87.84193	1	< 0.1%
-87.84012	1	< 0.1%
-87.83983	1	< 0.1%
-87.83528	1	< 0.1%
-87.83526	2	< 0.1%

Value	Count	Frequency (%)
-87.53752	1	< 0.1%
-87.5379	1	< 0.1%
-87.54496	1	< 0.1%
-87.54557	1	< 0.1%
-87.54593	1	< 0.1%
-87.54595	1	< 0.1%
-87.54596	2	< 0.1%
-87.54603	1	< 0.1%
-87.54615	1	< 0.1%
-87.54775	1	< 0.1%

room_type
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	44.2 KiB

Entire home/apt	3447
Private room	1441
Shared room	72
Hotel room	52

Length

Max length	15
Median length	15
Mean length	14.028132
Min length	10

Characters and Unicode

Total characters	70309
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	3447	68.8%
Private room	1441	28.8%
Shared room	72	1.4%
Hotel room	52	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	3447	34.4%
home/apt	3447	34.4%
room	1565	15.6%
private	1441	14.4%
shared	72	0.7%
hotel	52	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	8459	12.0%
t	8387	11.9%
o	6629	9.4%
r	6525	9.3%
	5012	7.1%
m	5012	7.1%
a	4960	7.1%
i	4888	7.0%
h	3519	5.0%
n	3447	4.9%
Other values (9)	13471	19.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	70309	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	8459	12.0%
t	8387	11.9%
o	6629	9.4%
r	6525	9.3%
	5012	7.1%
m	5012	7.1%
a	4960	7.1%
i	4888	7.0%
h	3519	5.0%
n	3447	4.9%
Other values (9)	13471	19.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	70309	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	8459	12.0%
t	8387	11.9%
o	6629	9.4%
r	6525	9.3%
	5012	7.1%
m	5012	7.1%
a	4960	7.1%
i	4888	7.0%
h	3519	5.0%
n	3447	4.9%
Other values (9)	13471	19.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	70309	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	8459	12.0%
t	8387	11.9%
o	6629	9.4%
r	6525	9.3%
	5012	7.1%
m	5012	7.1%
a	4960	7.1%
i	4888	7.0%
h	3519	5.0%
n	3447	4.9%
Other values (9)	13471	19.2%

price
Real number (ℝ)

High correlation

Distinct	448
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	139.92877

Minimum	14
Maximum	3429
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	14
5-th percentile	31
Q1	65
median	99
Q3	155
95-th percentile	393
Maximum	3429
Range	3415
Interquartile range (IQR)	90

Descriptive statistics

Standard deviation	165.88465
Coefficient of variation (CV)	1.1854935
Kurtosis	98.503701
Mean	139.92877
Median Absolute Deviation (MAD)	43
Skewness	7.4755277
Sum	701323
Variance	27517.716
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	110	2.2%
80	101	2.0%
75	99	2.0%
150	97	1.9%
100	88	1.8%
65	87	1.7%
70	84	1.7%
60	77	1.5%
90	76	1.5%
55	73	1.5%
Other values (438)	4120	82.2%

Value	Count	Frequency (%)
14	2	< 0.1%
15	6	0.1%
16	2	< 0.1%
17	2	< 0.1%
18	4	0.1%
19	4	0.1%
20	8	0.2%
21	9	0.2%
22	11	0.2%
23	6	0.1%

Value	Count	Frequency (%)
3429	1	< 0.1%
3070	1	< 0.1%
3000	1	< 0.1%
2788	1	< 0.1%
1999	1	< 0.1%
1921	1	< 0.1%
1828	1	< 0.1%
1500	3	0.1%
1499	1	< 0.1%
1400	1	< 0.1%

log_days_since_last_review
Real number (ℝ)

Distinct	675
Distinct (%)	13.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7741487

Minimum	-1
Maximum	3.38616
Zeros	0
Zeros (%)	0.0%
Negative	877
Negative (%)	17.5%
Memory size	78.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	2.0417873
median	2.1646502
Q3	2.5052857
95-th percentile	2.9047696
Maximum	3.38616
Range	4.38616
Interquartile range (IQR)	0.46349836

Descriptive statistics

Standard deviation	1.3060209
Coefficient of variation (CV)	0.73613947
Kurtosis	0.6702304
Mean	1.7741487
Median Absolute Deviation (MAD)	0.30088134
Skewness	-1.5376373
Sum	8892.0331
Variance	1.7056905
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	877	17.5%
2.06483222	157	3.1%
2.041787319	134	2.7%
2.465531557	120	2.4%
2.068556895	108	2.2%
2.505285674	81	1.6%
2.037824751	79	1.6%
2.090258053	76	1.5%
2.013258665	75	1.5%
2.093771781	68	1.4%
Other values (665)	3237	64.6%

Value	Count	Frequency (%)
-1	877	17.5%
2.009025742	2	< 0.1%
2.013258665	75	1.5%
2.01745073	36	0.7%
2.021602716	36	0.7%
2.025715384	42	0.8%
2.029789471	39	0.8%
2.033825694	42	0.8%
2.037824751	79	1.6%
2.041787319	134	2.7%

Value	Count	Frequency (%)
3.386159959	1	< 0.1%
3.374216605	1	< 0.1%
3.363066419	1	< 0.1%
3.356618542	1	< 0.1%
3.337479228	1	< 0.1%
3.311351158	1	< 0.1%
3.309864283	1	< 0.1%
3.300182295	1	< 0.1%
3.299311135	1	< 0.1%
3.296028636	1	< 0.1%

log_reviews_per_month
Real number (ℝ)

High correlation

Distinct	628
Distinct (%)	12.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.11839046

Minimum	-1
Maximum	1.5122841
Zeros	15
Zeros (%)	0.3%
Negative	2555
Negative (%)	51.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-0.60205999
median	-0.022276395
Q3	0.36735592
95-th percentile	0.67742064
Maximum	1.5122841
Range	2.5122841
Interquartile range (IQR)	0.96941591

Descriptive statistics

Standard deviation	0.5724843
Coefficient of variation (CV)	-4.8355609
Kurtosis	-1.1864983
Mean	-0.11839046
Median Absolute Deviation (MAD)	0.45920967
Skewness	-0.23456376
Sum	-593.37301
Variance	0.32773827
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	877	17.5%
0.04139268516	59	1.2%
-0.5686362358	48	1.0%
-0.6197887583	43	0.9%
-0.7447274949	41	0.8%
-0.585026652	36	0.7%
-0.721246399	33	0.7%
-0.8860566477	32	0.6%
-0.6575773192	32	0.6%
-0.4948500217	31	0.6%
Other values (618)	3780	75.4%

Value	Count	Frequency (%)
-1	877	17.5%
-0.920818754	12	0.2%
-0.8860566477	32	0.6%
-0.8538719643	27	0.5%
-0.8239087409	18	0.4%
-0.7958800173	23	0.5%
-0.7695510786	22	0.4%
-0.7447274949	41	0.8%
-0.721246399	33	0.7%
-0.6989700043	23	0.5%

Value	Count	Frequency (%)
1.512284063	1	< 0.1%
1.231214648	1	< 0.1%
1.071513805	1	< 0.1%
1.06595298	1	< 0.1%
1.051152522	1	< 0.1%
1.048053173	1	< 0.1%
1.044147621	1	< 0.1%
1.039810554	1	< 0.1%
1.025715384	1	< 0.1%
0.983175072	1	< 0.1%

log_number_of_reviews
Real number (ℝ)

High correlation

Distinct	308
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.90284451

Minimum	-1
Maximum	2.8007858
Zeros	0
Zeros (%)	0.0%
Negative	877
Negative (%)	17.5%
Memory size	78.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	0.32221929
median	1.1789769
Q3	1.7411516
95-th percentile	2.2407988
Maximum	2.8007858
Range	3.8007858
Interquartile range (IQR)	1.4189323

Descriptive statistics

Standard deviation	1.068376
Coefficient of variation (CV)	1.1833444
Kurtosis	-0.75978922
Mean	0.90284451
Median Absolute Deviation (MAD)	0.68761525
Skewness	-0.63728601
Sum	4525.0567
Variance	1.1414273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	877	17.5%
0.04139268516	326	6.5%
0.3222192947	225	4.5%
0.4913616938	185	3.7%
0.7075701761	117	2.3%
0.6127838567	117	2.3%
0.8512583487	102	2.0%
0.785329835	83	1.7%
0.9590413923	78	1.6%
0.9084850189	75	1.5%
Other values (298)	2827	56.4%

Value	Count	Frequency (%)
-1	877	17.5%
0.04139268516	326	6.5%
0.3222192947	225	4.5%
0.4913616938	185	3.7%
0.6127838567	117	2.3%
0.7075701761	117	2.3%
0.785329835	83	1.7%
0.8512583487	102	2.0%
0.9084850189	75	1.5%
0.9590413923	78	1.6%

Value	Count	Frequency (%)
2.80078579	1	< 0.1%
2.795949499	1	< 0.1%
2.733277534	1	< 0.1%
2.708505881	1	< 0.1%
2.704236337	1	< 0.1%
2.699056855	1	< 0.1%
2.69818757	2	< 0.1%
2.688508808	1	< 0.1%
2.663795122	1	< 0.1%
2.645520515	1	< 0.1%

log_price
Real number (ℝ)

High correlation

Distinct	448
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0112387

Minimum	1.146128
Maximum	3.5351675
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	1.146128
5-th percentile	1.4913617
Q1	1.8129134
median	1.9956352
Q3	2.1903317
95-th percentile	2.5943926
Maximum	3.5351675
Range	2.3890394
Interquartile range (IQR)	0.37741834

Descriptive statistics

Standard deviation	0.31855437
Coefficient of variation (CV)	0.15838715
Kurtosis	0.75905852
Mean	2.0112387
Median Absolute Deviation (MAD)	0.18945522
Skewness	0.45091562
Sum	10080.328
Variance	0.10147688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.698970004	110	2.2%
1.903089987	101	2.0%
1.875061263	99	2.0%
2.176091259	97	1.9%
2	88	1.8%
1.812913357	87	1.7%
1.84509804	84	1.7%
1.77815125	77	1.5%
1.954242509	76	1.5%
1.740362689	73	1.5%
Other values (438)	4120	82.2%

Value	Count	Frequency (%)
1.146128036	2	< 0.1%
1.176091259	6	0.1%
1.204119983	2	< 0.1%
1.230448921	2	< 0.1%
1.255272505	4	0.1%
1.278753601	4	0.1%
1.301029996	8	0.2%
1.322219295	9	0.2%
1.342422681	11	0.2%
1.361727836	6	0.1%

Value	Count	Frequency (%)
3.535167485	1	< 0.1%
3.487138375	1	< 0.1%
3.477121255	1	< 0.1%
3.445292769	1	< 0.1%
3.300812794	1	< 0.1%
3.283527365	1	< 0.1%
3.261976191	1	< 0.1%
3.176091259	3	0.1%
3.175801633	1	< 0.1%
3.146128036	1	< 0.1%

log_minimum_nights
Real number (ℝ)

High correlation Zeros

Distinct	48
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.45549834

Minimum	0
Maximum	2.2552725
Zeros	1521
Zeros (%)	30.3%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.30103
Q3	0.47712125
95-th percentile	1.4913617
Maximum	2.2552725
Range	2.2552725
Interquartile range (IQR)	0.47712125

Descriptive statistics

Standard deviation	0.50270629
Coefficient of variation (CV)	1.1036402
Kurtosis	0.65635319
Mean	0.45549834
Median Absolute Deviation (MAD)	0.30103
Skewness	1.2988705
Sum	2282.9577
Variance	0.25271361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0.3010299957	1628	32.5%
0	1521	30.3%
0.4771212547	685	13.7%
1.477121255	289	5.8%
0.6020599913	135	2.7%
1.491361694	109	2.2%
0.84509804	104	2.1%
1.505149978	87	1.7%
0.6989700043	85	1.7%
1.146128036	56	1.1%
Other values (38)	313	6.2%

Value	Count	Frequency (%)
0	1521	30.3%
0.3010299957	1628	32.5%
0.4771212547	685	13.7%
0.6020599913	135	2.7%
0.6989700043	85	1.7%
0.7781512504	25	0.5%
0.84509804	104	2.1%
0.903089987	1	< 0.1%
0.9542425094	1	< 0.1%
1	33	0.7%

Value	Count	Frequency (%)
2.255272505	7	0.1%
2.252853031	1	< 0.1%
2.176091259	1	< 0.1%
2.146128036	1	< 0.1%
2.079181246	4	0.1%
2	1	< 0.1%
1.959041392	2	< 0.1%
1.954242509	14	0.3%
1.944482672	1	< 0.1%
1.908485019	1	< 0.1%

log_host_listings_count
Real number (ℝ)

High correlation Zeros

Distinct	33
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.51731125

Minimum	0
Maximum	2.3117539
Zeros	2106
Zeros (%)	42.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.30103
Q3	0.84509804
95-th percentile	1.7923917
Maximum	2.3117539
Range	2.3117539
Interquartile range (IQR)	0.84509804

Descriptive statistics

Standard deviation	0.61568158
Coefficient of variation (CV)	1.190157
Kurtosis	0.62131458
Mean	0.51731125
Median Absolute Deviation (MAD)	0.30103
Skewness	1.1861676
Sum	2592.764
Variance	0.37906381
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	2106	42.0%
0.3010299957	674	13.4%
0.4771212547	349	7.0%
0.6020599913	296	5.9%
2.311753861	156	3.1%
0.6989700043	149	3.0%
0.7781512504	102	2.0%
0.84509804	101	2.0%
0.9542425094	94	1.9%
0.903089987	77	1.5%
Other values (23)	908	18.1%

Value	Count	Frequency (%)
0	2106	42.0%
0.3010299957	674	13.4%
0.4771212547	349	7.0%
0.6020599913	296	5.9%
0.6989700043	149	3.0%
0.7781512504	102	2.0%
0.84509804	101	2.0%
0.903089987	77	1.5%
0.9542425094	94	1.9%
1	58	1.2%

Value	Count	Frequency (%)
2.311753861	156	3.1%
1.86332286	57	1.1%
1.792391689	52	1.0%
1.672097858	75	1.5%
1.653212514	36	0.7%
1.643452676	36	0.7%
1.568201724	31	0.6%
1.491361694	52	1.0%
1.477121255	24	0.5%
1.447158031	27	0.5%

log_nights_booked
Real number (ℝ)

Distinct	361
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8789671

Minimum	-1
Maximum	2.5624118
Zeros	0
Zeros (%)	0.0%
Negative	286
Negative (%)	5.7%
Memory size	78.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	1.5575072
median	2.314078
Q3	2.5199592
95-th percentile	2.5624118
Maximum	2.5624118
Range	3.5624118
Interquartile range (IQR)	0.96245198

Descriptive statistics

Standard deviation	0.94971217
Coefficient of variation (CV)	0.50544375
Kurtosis	2.4930296
Mean	1.8789671
Median Absolute Deviation (MAD)	0.24833384
Skewness	-1.7945892
Sum	9417.383
Variance	0.90195321
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.562411833	942	18.8%
-1	286	5.7%
0.04139268516	127	2.5%
2.43949059	87	1.7%
2.441066407	75	1.5%
2.009025742	70	1.4%
2.269746373	62	1.2%
1.004321374	57	1.1%
2.267406419	57	1.1%
0.3222192947	51	1.0%
Other values (351)	3198	63.8%

Value	Count	Frequency (%)
-1	286	5.7%
0.04139268516	127	2.5%
0.3222192947	51	1.0%
0.4913616938	50	1.0%
0.6127838567	28	0.6%
0.7075701761	49	1.0%
0.785329835	36	0.7%
0.8512583487	29	0.6%
0.9084850189	21	0.4%
0.9590413923	22	0.4%

Value	Count	Frequency (%)
2.562411833	942	18.8%
2.561220679	43	0.9%
2.560026249	10	0.2%
2.558828525	22	0.4%
2.557627488	15	0.3%
2.556423121	8	0.2%
2.555215405	10	0.2%
2.554004321	12	0.2%
2.55278985	4	0.1%
2.551571974	7	0.1%

host_listings_minimum_nights
Real number (ℝ)

High correlation Zeros

Distinct	173
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.34913936

Minimum	0
Maximum	3.6413847
Zeros	3018
Zeros (%)	60.2%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.23424687
95-th percentile	2.4545485
Maximum	3.6413847
Range	3.6413847
Interquartile range (IQR)	0.23424687

Descriptive statistics

Standard deviation	0.7858197
Coefficient of variation (CV)	2.2507336
Kurtosis	7.0928592
Mean	0.34913936
Median Absolute Deviation (MAD)	0
Skewness	2.8090607
Sum	1749.8865
Variance	0.6175126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3018	60.2%
0.09061905829	242	4.8%
0.1436278092	223	4.4%
3.414740764	156	3.1%
0.1812381166	134	2.7%
0.2276446917	75	1.5%
0.2104109374	60	1.2%
0.2543998593	48	1.0%
0.2872556185	43	0.9%
0.5033516109	39	0.8%
Other values (163)	974	19.4%

Value	Count	Frequency (%)
0	3018	60.2%
0.09061905829	242	4.8%
0.1436278092	223	4.4%
0.1812381166	134	2.7%
0.2104109374	60	1.2%
0.2276446917	75	1.5%
0.2342468675	36	0.7%
0.2543998593	48	1.0%
0.2718571749	14	0.3%
0.2872556185	43	0.9%

Value	Count	Frequency (%)
3.641384742	1	< 0.1%
3.414740764	156	3.1%
3.313269874	20	0.4%
2.976064695	1	< 0.1%
2.804580363	5	0.1%
2.778888337	24	0.5%
2.752353801	4	0.1%
2.72491962	1	< 0.1%
2.696522642	1	< 0.1%
2.495605799	36	0.7%

price^2
Real number (ℝ)

High correlation Skewed

Distinct	448
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47092.287

Minimum	196
Maximum	11758041
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	196
5-th percentile	961
Q1	4225
median	9801
Q3	24025
95-th percentile	154449
Maximum	11758041
Range	11757845
Interquartile range (IQR)	19800

Descriptive statistics

Standard deviation	311866.53
Coefficient of variation (CV)	6.6224545
Kurtosis	783.44525
Mean	47092.287
Median Absolute Deviation (MAD)	7301
Skewness	25.383582
Sum	2.3602654 × 10⁸
Variance	9.7260731 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2500	110	2.2%
6400	101	2.0%
5625	99	2.0%
22500	97	1.9%
10000	88	1.8%
4225	87	1.7%
4900	84	1.7%
3600	77	1.5%
8100	76	1.5%
3025	73	1.5%
Other values (438)	4120	82.2%

Value	Count	Frequency (%)
196	2	< 0.1%
225	6	0.1%
256	2	< 0.1%
289	2	< 0.1%
324	4	0.1%
361	4	0.1%
400	8	0.2%
441	9	0.2%
484	11	0.2%
529	6	0.1%

Value	Count	Frequency (%)
11758041	1	< 0.1%
9424900	1	< 0.1%
9000000	1	< 0.1%
7772944	1	< 0.1%
3996001	1	< 0.1%
3690241	1	< 0.1%
3341584	1	< 0.1%
2250000	3	0.1%
2247001	1	< 0.1%
1960000	1	< 0.1%

price^3
Real number (ℝ)

High correlation Skewed

Distinct	448
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48392686

Minimum	2744
Maximum	4.0318323 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	2744
5-th percentile	29791
Q1	274625
median	970299
Q3	3723875
95-th percentile	60698457
Maximum	4.0318323 × 10¹⁰
Range	4.031832 × 10¹⁰
Interquartile range (IQR)	3449250

Descriptive statistics

Standard deviation	8.8382109 × 10⁸
Coefficient of variation (CV)	18.263526
Kurtosis	1333.1992
Mean	48392686
Median Absolute Deviation (MAD)	879174
Skewness	34.816864
Sum	2.4254414 × 10¹¹
Variance	7.8113971 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
125000	110	2.2%
512000	101	2.0%
421875	99	2.0%
3375000	97	1.9%
1000000	88	1.8%
274625	87	1.7%
343000	84	1.7%
216000	77	1.5%
729000	76	1.5%
166375	73	1.5%
Other values (438)	4120	82.2%

Value	Count	Frequency (%)
2744	2	< 0.1%
3375	6	0.1%
4096	2	< 0.1%
4913	2	< 0.1%
5832	4	0.1%
6859	4	0.1%
8000	8	0.2%
9261	9	0.2%
10648	11	0.2%
12167	6	0.1%

Value	Count	Frequency (%)
4.031832259 × 10¹⁰	1	< 0.1%
2.8934443 × 10¹⁰	1	< 0.1%
2.7 × 10¹⁰	1	< 0.1%
2.167096787 × 10¹⁰	1	< 0.1%
7988005999	1	< 0.1%
7088952961	1	< 0.1%
6108415552	1	< 0.1%
3375000000	3	0.1%
3368254499	1	< 0.1%
2744000000	1	< 0.1%

price^4
Real number (ℝ)

High correlation Skewed

Distinct	448
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.9459009 × 10¹⁰

Minimum	38416
Maximum	1.3825153 × 10¹⁴
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	38416
5-th percentile	923521
Q1	17850625
median	96059601
Q3	5.7720062 × 10⁸
95-th percentile	2.3854494 × 10¹⁰
Maximum	1.3825153 × 10¹⁴
Range	1.3825153 × 10¹⁴
Interquartile range (IQR)	5.5935 × 10⁸

Descriptive statistics

Standard deviation	2.7508166 × 10¹²
Coefficient of variation (CV)	27.657792
Kurtosis	1680.4379
Mean	9.9459009 × 10¹⁰
Median Absolute Deviation (MAD)	93499601
Skewness	39.253409
Sum	4.9848855 × 10¹⁴
Variance	7.5669921 × 10²⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6250000	110	2.2%
40960000	101	2.0%
31640625	99	2.0%
506250000	97	1.9%
100000000	88	1.8%
17850625	87	1.7%
24010000	84	1.7%
12960000	77	1.5%
65610000	76	1.5%
9150625	73	1.5%
Other values (438)	4120	82.2%

Value	Count	Frequency (%)
38416	2	< 0.1%
50625	6	0.1%
65536	2	< 0.1%
83521	2	< 0.1%
104976	4	0.1%
130321	4	0.1%
160000	8	0.2%
194481	9	0.2%
234256	11	0.2%
279841	6	0.1%

Value	Count	Frequency (%)
1.382515282 × 10¹⁴	1	< 0.1%
8.882874001 × 10¹³	1	< 0.1%
8.1 × 10¹³	1	< 0.1%
6.041865843 × 10¹³	1	< 0.1%
1.596802399 × 10¹³	1	< 0.1%
1.361787864 × 10¹³	1	< 0.1%
1.116618363 × 10¹³	1	< 0.1%
5.0625 × 10¹²	3	0.1%
5.049013494 × 10¹²	1	< 0.1%
3.8416 × 10¹²	1	< 0.1%

	host_listings_minimum_nights	latitude	log_days_since_last_review	log_host_listings_count	log_minimum_nights	log_nights_booked	log_number_of_reviews	log_price	log_reviews_per_month	longitude	neighbourhood	price	price^2	price^3	price^4	room_type
host_listings_minimum_nights	1.000	-0.181	-0.134	0.709	0.617	-0.269	-0.271	0.118	-0.270	0.237	0.199	0.118	0.118	0.118	0.118	0.118
latitude	-0.181	1.000	0.064	-0.186	-0.093	0.071	0.129	0.080	0.089	-0.521	0.671	0.080	0.080	0.080	0.080	0.148
log_days_since_last_review	-0.134	0.064	1.000	-0.193	-0.084	0.183	0.252	-0.028	0.078	-0.075	0.157	-0.028	-0.028	-0.028	-0.028	0.126
log_host_listings_count	0.709	-0.186	-0.193	1.000	0.156	-0.278	-0.214	0.038	-0.152	0.296	0.233	0.038	0.038	0.038	0.038	0.219
log_minimum_nights	0.617	-0.093	-0.084	0.156	1.000	-0.179	-0.274	0.135	-0.325	0.138	0.164	0.135	0.135	0.135	0.135	0.166
log_nights_booked	-0.269	0.071	0.183	-0.278	-0.179	1.000	0.028	-0.115	0.042	-0.079	0.095	-0.115	-0.115	-0.115	-0.115	0.095
log_number_of_reviews	-0.271	0.129	0.252	-0.214	-0.274	0.028	1.000	-0.109	0.882	-0.188	0.128	-0.109	-0.109	-0.109	-0.109	0.036
log_price	0.118	0.080	-0.028	0.038	0.135	-0.115	-0.109	1.000	-0.128	0.191	0.167	1.000	1.000	1.000	1.000	0.381
log_reviews_per_month	-0.270	0.089	0.078	-0.152	-0.325	0.042	0.882	-0.128	1.000	-0.169	0.115	-0.128	-0.128	-0.128	-0.128	0.103
longitude	0.237	-0.521	-0.075	0.296	0.138	-0.079	-0.188	0.191	-0.169	1.000	0.574	0.191	0.191	0.191	0.191	0.104
neighbourhood	0.199	0.671	0.157	0.233	0.164	0.095	0.128	0.167	0.115	0.574	1.000	0.029	0.000	0.000	0.000	0.217
price	0.118	0.080	-0.028	0.038	0.135	-0.115	-0.109	1.000	-0.128	0.191	0.029	1.000	1.000	1.000	1.000	0.069
price^2	0.118	0.080	-0.028	0.038	0.135	-0.115	-0.109	1.000	-0.128	0.191	0.000	1.000	1.000	1.000	1.000	0.000
price^3	0.118	0.080	-0.028	0.038	0.135	-0.115	-0.109	1.000	-0.128	0.191	0.000	1.000	1.000	1.000	1.000	0.000
price^4	0.118	0.080	-0.028	0.038	0.135	-0.115	-0.109	1.000	-0.128	0.191	0.000	1.000	1.000	1.000	1.000	0.000
room_type	0.118	0.148	0.126	0.219	0.166	0.095	0.036	0.381	0.103	0.104	0.217	0.069	0.000	0.000	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	neighbourhood	latitude	longitude	room_type	price	log_days_since_last_review	log_reviews_per_month	log_number_of_reviews	log_price	log_minimum_nights	log_host_listings_count	log_nights_booked	host_listings_minimum_nights	price^2	price^3	price^4
1930	infrequent	41.79359	-87.70345	Private room	46	2.049606	0.662758	2.209783	1.662758	0.000000	0.477121	0.041393	0.000000	2116	97336	4477456
5588	North Center	41.95803	-87.69214	Entire home/apt	120	-1.000000	-1.000000	-1.000000	2.079181	0.301030	0.000000	2.453471	0.000000	14400	1728000	207360000
599	Logan Square	41.92654	-87.72505	Entire home/apt	146	2.598900	0.230449	2.000434	2.164353	0.301030	0.000000	2.267406	0.000000	21316	3112136	454371856
778	Rogers Park	42.00451	-87.66203	Entire home/apt	135	2.179264	0.103804	1.826723	2.130334	0.845098	0.000000	2.465532	0.000000	18225	2460375	332150625
1509	South Shore	41.76867	-87.56926	Private room	22	2.068557	0.064458	1.613842	1.342423	0.000000	0.301030	1.663701	0.000000	484	10648	234256
3660	Bridgeport	41.84030	-87.65903	Entire home/apt	118	2.064832	0.113943	1.303196	2.071882	0.301030	0.301030	2.532882	0.090619	13924	1643032	193877776
766	North Center	41.94629	-87.68011	Entire home/apt	179	3.221179	-0.853872	0.322219	2.252853	0.477121	0.477121	2.561221	0.227645	32041	5735339	1026625681
4018	Near North Side	41.89502	-87.62791	Entire home/apt	130	-1.000000	-1.000000	-1.000000	2.113943	1.477121	2.311754	1.324282	3.414741	16900	2197000	285610000
2416	Bridgeport	41.83363	-87.65166	Private room	44	2.179264	-0.050610	1.363612	1.643453	0.477121	0.000000	2.441066	0.000000	1936	85184	3748096
4429	Logan Square	41.92595	-87.69130	Entire home/apt	110	2.634578	-0.187087	0.851258	2.041393	0.477121	0.000000	2.562412	0.000000	12100	1331000	146410000

	neighbourhood	latitude	longitude	room_type	price	log_days_since_last_review	log_reviews_per_month	log_number_of_reviews	log_price	log_minimum_nights	log_host_listings_count	log_nights_booked	host_listings_minimum_nights	price^2	price^3	price^4
2709	infrequent	41.92027	-87.77840	Private room	115	2.712734	-0.481486	0.785330	2.060698	0.301030	0.602060	-1.000000	0.181238	13225	1520875	174900625
3418	Near North Side	41.89163	-87.63800	Entire home/apt	109	-1.000000	-1.000000	-1.000000	2.037426	2.079181	0.698970	-1.000000	1.453285	11881	1295029	141158161
1082	Logan Square	41.92309	-87.68304	Entire home/apt	70	2.041787	0.356026	2.045714	1.845098	0.301030	0.000000	2.453471	0.000000	4900	343000	24010000
4185	Near West Side	41.88340	-87.64307	Entire home/apt	400	2.621280	-0.481486	0.491362	2.602060	0.301030	0.778151	2.562412	0.234247	160000	64000000	25600000000
1356	Avondale	41.93312	-87.70809	Private room	139	2.503927	-0.013228	1.545307	2.143015	0.000000	0.000000	2.408410	0.000000	19321	2685619	373301041
187	West Town	41.90669	-87.68283	Entire home/apt	114	2.674953	0.315970	2.198932	2.056905	0.301030	0.000000	2.562412	0.000000	12996	1481544	168896016
3228	East Garfield Park	41.87980	-87.70136	Entire home/apt	79	2.100715	0.631444	1.949878	1.897627	0.602060	0.477121	2.539202	0.287256	6241	493039	38950081
2192	North Center	41.94383	-87.68014	Entire home/apt	128	2.072250	0.463893	1.909021	2.107210	0.602060	0.000000	1.324282	0.000000	16384	2097152	268435456
638	Lake View	41.95045	-87.65558	Entire home/apt	125	2.778224	-0.795880	0.491362	2.096910	0.000000	0.000000	2.562412	0.000000	15625	1953125	244140625
5690	Logan Square	41.92068	-87.71599	Entire home/apt	106	2.017451	0.322219	0.322219	2.025306	0.602060	0.903090	2.447313	0.543714	11236	1191016	126247696

Most frequently occurring

	neighbourhood	latitude	longitude	room_type	price	log_days_since_last_review	log_reviews_per_month	log_number_of_reviews	log_price	log_minimum_nights	log_host_listings_count	log_nights_booked	host_listings_minimum_nights	price^2	price^3	price^4	# duplicates
0	Loop	41.87723	-87.62901	Entire home/apt	150	-1.0	-1.0	-1.0	2.176091	1.477121	2.311754	1.845718	3.414741	22500	3375000	506250000	2
1	Near North Side	41.89502	-87.62791	Entire home/apt	152	-1.0	-1.0	-1.0	2.181844	1.477121	2.311754	1.851870	3.414741	23104	3511808	533794816	2
2	Near West Side	41.88306	-87.65131	Entire home/apt	98	-1.0	-1.0	-1.0	1.991226	1.477121	2.311754	0.041393	3.414741	9604	941192	92236816	2

Overview

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring